CREATE EXTERNAL TABLE jms_dwd.dwd_tab_barscan_other_base_dt(
    record_id string comment'记录编号_ef',
    waybill_no string comment'运单编号_ef',
    list_code string comment'清单编号',
    subbill_code string comment'子单号',
    shipment_no string comment'任务号_ef',
    package_code string comment'所属包号',
    scan_type string comment'扫描类型_ef',
    next_station string comment'上一站或下一站',
    destination string comment'目的地点',
    scan_user string comment'扫描雇员_ef',
    scan_site string comment'扫描网点_ef',
    scan_time timestamp comment'扫描时间_ef',
    input_time timestamp comment'入库时间_ef',
    operate_date timestamp comment'操作日期_ef',
    send_deliver_user string comment'派件或收件员',
    send_customer string comment'寄件客户',
    send_site string comment'寄件网点_ef',
    dest_site string comment'目的网点',
    transfer_center string comment'中转中心',
    pcs bigint comment'件数',
    weight double comment'重量',
    goods_type string comment'物品类别',
    express_type string comment'快件类型',
    shifts string comment'班次',
    transfer_deliver_fee double comment'中转或派件费',
    network_manage_fee double comment'网管费',
    other_fee double comment'其他费',
    check_flag string comment'核算标识',
    account_flag bigint comment'对帐标识',
    receipt_flag tinyint comment'回单标识',
    return_flag tinyint comment'退件标识',
    ele_scale_flag string comment'电子秤标识',
    unrecord_flag tinyint comment'未录单标识',
    write_back_flag bigint comment'回写标识',
    lock_flag tinyint comment'锁定标识',
    vehicle_num string comment'车牌号_ef',
    modify_user string comment'修改人',
    modify_time timestamp comment'修改时间',
    mobile string comment'手机号码',
    pistol_id string comment'巴枪ID_ef',
    remark1 string comment'备注1',
    remark2 string comment'备注2',
    scan_site_code string comment'扫描网点编号_ef',
    upload_time timestamp comment'上传时间_ef',
    remark3 string comment'备注3',
    scan_user_code string comment'扫描雇员编号_ef',
    send_deliver_user_code string comment'收派员编号',
    next_station_code string comment'上下一站编号',
    source string comment'来源_ef',
    remark5 string comment'备注5',
    remark6 double comment'备注6',
    list_code2 string comment'清单编号_ef',
    scan_site_id bigint comment'扫描网点ID_ef',
    next_station_id bigint comment'上一站/下一站ID',
    scan_user_id bigint comment'扫描雇员ID_ef',
    send_deliver_user_id bigint comment'收派员ID',
    network_type tinyint comment'扫描网点类型，1.加盟商,2.转运中心,3.集散点,4.普通网点,5.代理区,6.总部,0.其他',
    site_agent_code string comment'所属代理区code',
    site_agent_name string comment'所属代理区名称',
    site_franchisee_code string comment'所属加盟商code ',
    site_franchisee_name string comment'所属加盟商名称',
    site_transcenter_code string comment'所属转运中心code',
    site_transcenter_name string comment'所属转运中心名称',
    next_network_type tinyint comment'下一站网点类型，1.加盟商,2.转运中心,3.集散点,4.普通网点,5.代理区,6.总部,0.其他',
    waybill_source string comment'运单来源：GB:国标单号,BS:百世单号,BSB:百世包号,JT:极兔单号,JTB:极兔包号,Other:其它'
) COMMENT '操作平台-其它表(封发车，到解车，拆包，装车发件，卸车到件，留仓件入仓)'
PARTITIONED BY (
  `dt` string COMMENT '时间分区-inputtime')
stored as parquet
location "/dw/hive/jms_dwd.db/external/dwd_tab_barscan_other_base_dt"
